Segoe UI 0 SQL Data Source=.\ORGANICE;Initial Catalog=orgAniceCRM7 true Integrated 73631d92-a5e9-4c30-ac19-4c35a76875bd OrgDataSource =Parameters!DateParameter.Value SELECT * FROM [dbo].[ufnEmployeePlanning](NULL, 2, @DateParameter, 0, 7) WHERE Typ = 'MitarbeiterPlanung' OR Typ = 'Außentermin' ID System.String Name System.String Betreff System.String Datum System.DateTime DatumBis System.DateTime Verantwortlich System.String UserFullName System.String TableName System.String RecordOid System.String Typ System.String Memo System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM [dbo].[ufnBirthdays](@UserNameParameter, 2, @DateParameter, 3, 3) true ID System.String Vorname System.String Name System.String Geburtstag System.DateTime Age System.Int32 TableName System.String RecordOid System.String OrgDataSource =Parameters!DateParameter.Value =Parameters!UserNameParameter.Value SELECT * FROM ufnActivities(@UserNameParameter, 2, @DateParameter, 3, 3) ID System.String Name System.String Betreff System.String Datum System.DateTime DatumBis System.DateTime Verantwortlich System.String UserFullName System.String TableName System.String RecordOid System.String Typ System.String Memo System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnEvents(@UserNameParameter, 2, @DateParameter) ID System.String Bezeichnung System.String Von System.DateTime Bis System.DateTime TableName System.String RecordOid System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnCompanyNews(@UserNameParameter, 2, @DateParameter) ID System.String Betreff System.String Inhalt System.String GueltigVom System.DateTime GueltigBis System.DateTime Verantwortlich System.String TableName System.String RecordOid System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnSalesOpportunities(@UserNameParameter, 2, @DateParameter, NULL) EndDatum System.DateTime Name System.String Betreff System.String Status System.String SummeNettoNormaleUSt System.Double Verantwortlich System.String SummeNettoNormaleUStChance System.Double SummeBruttoNormaleUSt System.Double TableName2 System.String RecordOID2 System.String TableName System.String RecordOID System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnNumberOpenProcessesByStatus(@UserNameParameter, 2, @DateParameter, NULL) Status System.String TableName System.String RecordOID System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnSalesOpenProcessesByStatus(@UserNameParameter, 2, @DateParameter, NULL) Status System.String SummeNettoOhneUSt System.Double SummeNettoNormaleUSt System.Double TableName System.String SummeNettoErmaessigteUSt System.Double RecordOID System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnSalesOpenProcessesByEmployee(@UserNameParameter, 2, @DateParameter, NULL) Verantwortlich System.String SummeNettoOhneUSt System.Double SummeNettoNormaleUSt System.Double TableName System.String SummeNettoErmaessigteUSt System.Double RecordOID System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnFavorites(@UserNameParameter, 2, @DateParameter) ID System.String FavoritesTableName System.String TableName System.String RecordID System.String ExpressionValue System.String User System.String RecordOID System.String OrgDataSource =Parameters!UserNameParameter.Value =Parameters!DateParameter.Value SELECT * FROM ufnProjects(@UserNameParameter, 2, @DateParameter) Projektname System.String Projektzusatz System.String Leistung1 System.String Leistung2 System.String TableName System.String RecordOid System.String 57.05555mm 56.26181mm 6mm true true Geburtstage Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 2 6mm true true Keine Geburtstage Textbox34 2pt 2pt 2pt 2pt 2 6.35278mm true true =Fields!Vorname.Value & " " & Fields!Name.Value 2pt 2pt 2pt 2pt true true =Fields!Geburtstag.Value & " - " & Fields!Age.Value & ". Geburtstag" Betreff1 2pt 2pt 2pt 2pt After =CountRows() > 0 After Birthdays =IIF( Month(Parameters!DateParameter.Value)=12 AND Month(Fields!Geburtstag.Value)=1, Month(Parameters!DateParameter.Value)+1, Month(Fields!Geburtstag.Value) ) =Day(Fields!Geburtstag.Value) 20.18444mm 2.0165mm 18.35278mm 113.31736mm 57.05555mm 56.26181mm 6mm true true Aktivitäten Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 2 6mm true true Keine Aktivitäten Textbox36 2pt 2pt 2pt 2pt 2 6.35278mm true true =Fields!Betreff.Value 2pt 2pt 2pt 2pt true true =Fields!Name.Value & " " & FormatDateTime(Fields!Datum.Value, DateFormat.ShortDate) & " - " & IIF(Year(Fields!DatumBis.Value)>1899, FormatDateTime(Fields!DatumBis.Value, DateFormat.ShortDate), "") 2pt 2pt 2pt 2pt 4.4125mm true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt After =CountRows() > 0 After Before Activities =Fields!Datum.Value 3.41916mm 2.0165mm 22.76528mm 113.31736mm 1 32.9906mm 48.601mm 6mm true true Events Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 2 6mm true true Keine Events Textbox39 2pt 2pt 2pt 2pt 2 6.35278mm true true =Fields!Bezeichnung.Value 2pt 2pt 2pt 2pt true true =Fields!Von.Value & " (" & FormatDateTime(Fields!Von.Value , DateFormat.ShortDate) & " - " & FormatDateTime(Fields!Bis.Value, DateFormat.ShortDate) & ")" 2pt 2pt 2pt 2pt 4.4125mm true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt After =CountRows() > 0 After Before Events 2.36083mm 1.14652mm 22.76528mm 81.5916mm 81.5916mm 6mm true true Firmen-News Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 6mm true true Keine Firmen-News Textbox39 2pt 2pt 2pt 2pt 6.35278mm true true =Fields!GueltigVom.Value & " - " & Fields!Betreff.Value 2pt 2pt 2pt 2pt 6mm true true =Fields!Inhalt.Value HTML 2pt 2pt 2pt 2pt After =CountRows() > 0 After CompanyNews =Fields!GueltigVom.Value Descending 19.12611mm 1.14653mm 24.35278mm 81.5916mm 1 40.87033mm 40.07659mm 1.71362mm true true Textbox28 2pt 2pt 2pt 2pt 2 6mm true true Meine aktuellen Projekte Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 2 6mm true true Keine Projekte Textbox34 2pt 2pt 2pt 2pt 2 6.35278mm true true =Fields!Projektname.Value & " - " & Fields!Projektzusatz.Value 2pt 2pt 2pt 2pt true true =Fields!Leistung1.Value & " " & Fields!Leistung2.Value Betreff1 2pt 2pt 2pt 2pt After After =CountRows() > 0 After Projects 33mm 1.14652mm 20.0664mm 80.94692mm 2 =IIF(CountRows("Projects") < 1, TRUE, FALSE) true 1.05833mm 211.85211mm 55.56895mm 82.99095mm 2 32.36181mm 59.03667mm 6mm true true Abwesenheiten Zukünftig Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 2 6mm true true Keine Abwesenheiten Textbox39 2pt 2pt 2pt 2pt 2 6.35278mm true true =IIF(Len(Fields!UserFullName.Value) = 0, Fields!Verantwortlich.Value, Fields!UserFullName.Value) Middle 2pt 2pt 2pt 2pt true true =Fields!Betreff.Value 2pt 2pt 2pt 2pt After =CountRows() > 0 After Absence =DateValue(Fields!Datum.Value) GreaterThan =DateValue(Parameters!DateParameter.Value) =Fields!Datum.Value 19.12611mm 1.81827mm 18.35278mm 91.39848mm 32.36181mm 59.03667mm 6mm true true Abwesenheiten Aktuell Textbox16 LightGoldenrodYellow 2pt 2pt 2pt 2pt 2 6mm true true Keine Abwesenheiten Textbox39 2pt 2pt 2pt 2pt 2 6.35278mm true true =IIF(Len(Fields!UserFullName.Value) = 0, Fields!Verantwortlich.Value, Fields!UserFullName.Value) Middle 2pt 2pt 2pt 2pt true true =Fields!Betreff.Value 2pt 2pt 2pt 2pt 4.4125mm true true Middle 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt After =CountRows() > 0 After Before Absence =DateValue(Fields!Datum.Value) LessThanOrEqual =DateValue(Parameters!DateParameter.Value) =Fields!Datum.Value 2.36083mm 1.81824mm 22.76528mm 91.39848mm 1 true 0.70556mm 116.8715mm 39.41917mm 93.21675mm 3 26.93999mm 28.35143mm 7.41101mm true true Summe (Netto) Textbox14 #46688b Middle 2pt 2pt 2pt 2pt true true Summe (Brutto) Textbox15 #46688b Middle 2pt 2pt 2pt 2pt 5.99999mm true true =Sum(Fields!SummeNettoNormaleUSt.Value) Middle 2pt 2pt 2pt 2pt de-DE true true =Sum(Fields!SummeBruttoNormaleUSt.Value) Middle 2pt 2pt 2pt 2pt de-DE 6mm true true =Sum(Fields!SummeNettoNormaleUSt.Value) 2pt 2pt 2pt 2pt de-DE true true =Sum(Fields!SummeBruttoNormaleUSt.Value) 2pt 2pt 2pt 2pt de-DE 38.29486mm true true Status Textbox41 #46688b Middle 2pt 2pt 2pt 2pt 24.17188mm true true Datum Textbox25 #46688b Middle 2pt 2pt 2pt 2pt 65.09277mm true true Name Textbox23 #46688b Middle 2pt 2pt 2pt 2pt 88.83293mm true true Betreff Textbox21 #46688b Middle 2pt 2pt 2pt 2pt 20.7794mm true true MA Textbox17 #46688b Middle 2pt 2pt 2pt 2pt =Fields!Status.Value =Fields!Status.Value = "Verloren" =Fields!Status.Value = "Fakturiert" =Fields!Status.Value = "Teilfakturiert" =Fields!Status.Value = "Gewonnen" =Fields!Status.Value = "Beauftragt" =Fields!Status.Value = "sicherer Auftrag" =Fields!Status.Value = "geplanter Auftrag" =Fields!Status.Value = "Abschlussphase" =Fields!Status.Value = "Fortgeschritten" =Fields!Status.Value = "Alternativangebot" =Fields!Status.Value = "Angebot verschickt" =Fields!Status.Value = "Angebot erstellt" =Fields!Status.Value = "Anfangsphase" 38.29486mm true true =Fields!Status.Value Top 2pt 2pt 2pt 2pt =Fields!Name.Value =Fields!EndDatum.Value =Fields!Betreff.Value =Fields!Verantwortlich.Value =Fields!EndDatum.Value 24.17188mm true true =Fields!EndDatum.Value Middle 2pt 2pt 2pt 2pt 65.09277mm true true =Fields!Name.Value Middle 2pt 2pt 2pt 2pt 88.83293mm true true =Fields!Betreff.Value Middle 2pt 2pt 2pt 2pt 20.7794mm true true =Fields!Verantwortlich.Value Verantwortlich Middle 2pt 2pt 2pt 2pt =CountRows("Status")>5 TextBoxStatus 24.17188mm true true 2pt 2pt 2pt 2pt 65.09277mm true true 2pt 2pt 2pt 2pt 88.83293mm true true 2pt 2pt 2pt 2pt 20.7794mm true true Textbox48 2pt 2pt 2pt 2pt Before true SalesOpportunities =Fields!EndDatum.Value 10.3235mm 0.32234mm 19.411mm 292.46326mm =IIF(CountRows("SalesOpportunities") < 1, TRUE, FALSE) true true Vertriebstrichter Textbox2 0mm 0.34033mm 9.26517mm 377.20011mm 1 =IIF(CountRows("SalesOpportunities") < 1, TRUE, FALSE) #46688b Middle 2pt 2pt 2pt 2pt =Fields!Verantwortlich.Value =Sum(Fields!SummeNettoNormaleUSt.Value) + Sum(Fields!SummeNettoOhneUSt.Value) + Sum(Fields!SummeNettoErmaessigteUSt.Value) =Sum(Fields!SummeNettoNormaleUSt.Value) + Sum(Fields!SummeNettoOhneUSt.Value) + Sum(Fields!SummeNettoErmaessigteUSt.Value) true Primary Primary Black 0pt Achsentitel False 0.5 NaN NaN NaN Achsentitel False 0.5 NaN Opposite NaN NaN Achsentitel 0.5 NaN NaN NaN Achsentitel 0.5 NaN Opposite NaN NaN gewichtetes Umsatzvolumen offener Vorgänge nach Mitarbeiter BottomLeft BrightPastel Keine Daten verfügbar SalesOpenProcessesByEmployee 131.52778mm 0mm 64mm 82.72014mm =IIF(CountRows("SalesOpportunities") < 1, TRUE, FALSE) #e7e7ef None =Fields!Status.Value =Fields!Status.Value = "Verloren" =Fields!Status.Value = "Fakturiert" =Fields!Status.Value = "Teilfakturiert" =Fields!Status.Value = "Gewonnen" =Fields!Status.Value = "Beauftragt" =Fields!Status.Value = "sicherer Auftrag" =Fields!Status.Value = "geplanter Auftrag" =Fields!Status.Value = "Abschlussphase" =Fields!Status.Value = "Fortgeschritten" =Fields!Status.Value = "Alternativangebot" =Fields!Status.Value = "Angebot verschickt" =Fields!Status.Value = "Angebot erstellt" =Fields!Status.Value = "Anfangsphase" =Fields!Status.Value =Count(Fields!Status.Value) true Primary Primary Black 0pt Achsentitel False 0.5 NaN NaN NaN Achsentitel False 0.5 NaN Opposite NaN NaN Achsentitel 0.5 NaN NaN NaN Achsentitel 0.5 NaN Opposite NaN NaN Anzahl offener Vorgänge nach Status BottomLeft BrightPastel Keine Daten verfügbar NumberOpenProcessesByStatus 0mm 0.25837mm 64mm 82.99095mm 1 =IIF(CountRows("SalesOpportunities") < 1, TRUE, FALSE) #e7e7ef None =Fields!Status.Value =Sum(Fields!SummeNettoNormaleUSt.Value) + Sum(Fields!SummeNettoOhneUSt.Value) + Sum(Fields!SummeNettoErmaessigteUSt.Value) NotEqual =0 =Fields!Status.Value = "Verloren" =Fields!Status.Value = "Fakturiert" =Fields!Status.Value = "Teilfakturiert" =Fields!Status.Value = "Gewonnen" =Fields!Status.Value = "Beauftragt" =Fields!Status.Value = "sicherer Auftrag" =Fields!Status.Value = "geplanter Auftrag" =Fields!Status.Value = "Abschlussphase" =Fields!Status.Value = "Fortgeschritten" =Fields!Status.Value = "Alternativangebot" =Fields!Status.Value = "Angebot verschickt" =Fields!Status.Value = "Angebot erstellt" =Fields!Status.Value = "Anfangsphase" =Fields!Status.Value =Sum(Fields!SummeNettoNormaleUSt.Value) + Sum(Fields!SummeNettoOhneUSt.Value) + Sum(Fields!SummeNettoErmaessigteUSt.Value) true Primary Primary Black 0pt Achsentitel False 0.5 NaN NaN NaN Achsentitel False 0.5 NaN Opposite NaN NaN Achsentitel 0.5 NaN NaN NaN Achsentitel 0.5 NaN Opposite NaN NaN gewichtetes Umsatzvolumen offener Vorgänge nach Status (Netto) BottomLeft BrightPastel Keine Daten verfügbar SalesOpenProcessesByStatus 65.76389mm 0.25837mm 64mm 82.73258mm 2 =IIF(CountRows("SalesOpportunities") < 1, TRUE, FALSE) #e7e7ef None true 10.3235mm 294.27868mm 195.52778mm 83.3375mm 2 true 59.80228mm 1.15995mm 206.55683mm 378.24288mm 4 82.72014mm 6mm true true Keine Favoriten Textbox39 2pt 2pt 2pt 2pt 6.35278mm true true =Fields!FavoritesTableName.Value Middle 2pt 2pt 2pt 2pt 6.35278mm true true =Fields!ExpressionValue.Value 2pt 2pt 2pt 2pt 6mm true true Favoriten Textbox23 LightGoldenrodYellow 2pt 2pt 2pt 2pt =CountRows() > 0 After =Fields!FavoritesTableName.Value =Fields!FavoritesTableName.Value After Favorites 2.00806mm 0.01244mm 24.70556mm 82.72014mm true 1.05833mm 296.59451mm 30.77334mm 83.43502mm 5 282.23411mm #e7e7ef 380.94438mm 14.42861mm true true true true true Dashboard für =Parameters!FullNameParameter.Value Title ReportTitle 6.12069mm 0.25867cm 8.30792mm 292.00353mm Bottom 2pt 2pt 2pt 2pt true true erstellt am =Globals!ExecutionTime ExecutionTime 6.12069mm 296.33614mm 8.30792mm 82.99095mm 1 Middle 2pt 2pt 2pt 2pt #e7e7ef 29.7cm 21cm 2cm 2cm 2cm 2cm 0.13cm